2013-05-22 - 4674.1200 - Rel Notes - BI Reports Issues - Release 005 #BIReleases2013
Release Notes:
4674.1200 - BI Reports Issues - FI130
Admin Info
Purpose
|
To fix the issues in BOBI 4.0 Production server
|
Release No
|
005
|
Submitted
|
05-22-2013
|
Submitted by
|
Praveen Guntuka
|
Source/Destination Systems
|
IT > BMS > Quality to IT > BMS > Production in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Praveen Guntuka
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
FI130 - Income Statement By SBU
BEx Query
ZMP_GLPC_Q002
NEC Crystal Reports Standards Check
1. FI130 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. FI130 NEC CR checklist has been sent to NEC and also attached here for reference:
Summary Level Check
Test Conducted
Group : 5th & Ocean Clothing, LLC - Apparel Men -> Sales net
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
49,543
|
49,543
|
Pass
|
2
|
Budget
|
300,000
|
300,000
|
Pass
|
3
|
Variance
|
-250,457
|
-250,457
|
Pass
|
4
|
Var%
|
-83
|
-83
|
Pass
|
5
|
Actual
|
293,581
|
293,581
|
Pass
|
6
|
Budget
|
900,000
|
900,000
|
Pass
|
7
|
Variance
|
-606,419
|
-606,419
|
Pass
|
8
|
Var%
|
-67
|
-67
|
Pass
|
Group : 5th & Ocean Clothing, LLC - Apparel Men -> Cost of goods sold
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
30,707
|
30,707
|
Pass
|
2
|
Budget
|
164,850
|
164,850
|
Pass
|
3
|
Variance
|
-134,143
|
-134,143
|
Pass
|
4
|
Var%
|
-81
|
-81
|
Pass
|
5
|
Actual
|
186,409
|
186,409
|
Pass
|
6
|
Budget
|
494,550
|
494,550
|
Pass
|
7
|
Variance
|
-308,141
|
-308,141
|
Pass
|
8
|
Var%
|
-62
|
-62
|
Pass
|
Group : 5th & Ocean Clothing, LLC - Apparel Men -> Gross Profit
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
18,836
|
18,836
|
Pass
|
2
|
Budget
|
135,150
|
135,150
|
Pass
|
3
|
Variance
|
-116,314
|
-116,314
|
Pass
|
4
|
Var%
|
-86
|
-86
|
Pass
|
5
|
Actual
|
107,172
|
107,172
|
Pass
|
6
|
Budget
|
405,450
|
405,450
|
Pass
|
7
|
Variance
|
-298,278
|
-298,278
|
Pass
|
8
|
Var%
|
-74
|
-74
|
Pass
|
Group : 5th & Ocean Clothing, LLC - Apparel Men -> Selling and distribution expenses
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
19,844
|
19,844
|
Pass
|
2
|
Budget
|
17,134
|
17,134
|
Pass
|
3
|
Variance
|
2,710
|
2,710
|
Pass
|
4
|
Var%
|
16
|
16
|
Pass
|
5
|
Actual
|
91,470
|
91,470
|
Pass
|
6
|
Budget
|
78,404
|
78,404
|
Pass
|
7
|
Variance
|
13,066
|
13,066
|
Pass
|
8
|
Var%
|
17
|
17
|
Pass
|
Group : 5th & Ocean Clothing, LLC - Apparel Men -> Operating Profit
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
-1,008
|
-1,008
|
Pass
|
2
|
Budget
|
118,016
|
118,016
|
Pass
|
3
|
Variance
|
-119,024
|
-119,024
|
Pass
|
4
|
Var%
|
-101
|
-101
|
Pass
|
5
|
Actual
|
15,702
|
15,702
|
Pass
|
6
|
Budget
|
327,046
|
327,046
|
Pass
|
7
|
Variance
|
-311,344
|
-311,344
|
Pass
|
8
|
Var%
|
-95
|
-95
|
Pass
|
Group : 5th & Ocean Clothing, LLC - Apparel Men -> Net Income
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
-1,008
|
-1,008
|
Pass
|
2
|
Budget
|
118,016
|
118,016
|
Pass
|
3
|
Variance
|
-119,024
|
-119,024
|
Pass
|
4
|
Var%
|
-101
|
-101
|
Pass
|
5
|
Actual
|
15,702
|
15,702
|
Pass
|
6
|
Budget
|
327,046
|
327,046
|
Pass
|
7
|
Variance
|
-311,344
|
-311,344
|
Pass
|
8
|
Var%
|
-95
|
-95
|
Pass
|
Group : NEC, Inc, USA - Accessories -> Sales net
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
22,502
|
22,502
|
Pass
|
2
|
Budget
|
80,000
|
80,000
|
Pass
|
3
|
Variance
|
-57,498
|
-57,498
|
Pass
|
4
|
Var%
|
-72
|
-72
|
Pass
|
5
|
Actual
|
173,570
|
173,570
|
Pass
|
6
|
Budget
|
240,000
|
240,000
|
Pass
|
7
|
Variance
|
-66,430
|
-66,430
|
Pass
|
8
|
Var%
|
-28
|
-28
|
Pass
|
Group : NEC, Inc, USA - Accessories -> Cost of goods sold
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
10,692
|
10,692
|
Pass
|
2
|
Budget
|
48,000
|
48,000
|
Pass
|
3
|
Variance
|
-37,308
|
-37,308
|
Pass
|
4
|
Var%
|
-78
|
-78
|
Pass
|
5
|
Actual
|
102,340
|
102,340
|
Pass
|
6
|
Budget
|
144,000
|
144,000
|
Pass
|
7
|
Variance
|
-41,660
|
-41,660
|
Pass
|
8
|
Var%
|
-29
|
-29
|
Pass
|
Group : NEC, Inc, USA - Accessories -> Gross Profit
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
11,810
|
11,810
|
Pass
|
2
|
Budget
|
32,000
|
32,000
|
Pass
|
3
|
Variance
|
-20,190
|
-20,190
|
Pass
|
4
|
Var%
|
-63
|
-63
|
Pass
|
5
|
Actual
|
71,230
|
71,230
|
Pass
|
6
|
Budget
|
96,000
|
96,000
|
Pass
|
7
|
Variance
|
-24,770
|
-24,770
|
Pass
|
8
|
Var%
|
-26
|
-26
|
Pass
|
Group : NEC, Inc, USA - Accessories -> Selling and distribution expenses
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
19,226
|
19,226
|
Pass
|
2
|
Budget
|
35,425
|
35,425
|
Pass
|
3
|
Variance
|
-16,199
|
-16,199
|
Pass
|
4
|
Var%
|
-46
|
-46
|
Pass
|
5
|
Actual
|
91,277
|
91,277
|
Pass
|
6
|
Budget
|
144,335
|
144,335
|
Pass
|
7
|
Variance
|
-53,058
|
-53,058
|
Pass
|
8
|
Var%
|
-37
|
-37
|
Pass
|
Group : NEC, Inc, USA - Accessories -> Operating Profit
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
-7,416
|
-7,416
|
Pass
|
2
|
Budget
|
-3,425
|
-3,425
|
Pass
|
3
|
Variance
|
-3,991
|
-3,991
|
Pass
|
4
|
Var%
|
117
|
117
|
Pass
|
5
|
Actual
|
-20,046
|
-20,046
|
Pass
|
6
|
Budget
|
-48,335
|
-48,335
|
Pass
|
7
|
Variance
|
28,289
|
28,289
|
Pass
|
8
|
Var%
|
-59
|
-59
|
Pass
|
Group : NEC, Inc, USA - Accessories -> Net Income
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
-7,416
|
-7,416
|
Pass
|
2
|
Budget
|
-3,425
|
-3,425
|
Pass
|
3
|
Variance
|
-3,991
|
-3,991
|
Pass
|
4
|
Var%
|
117
|
117
|
Pass
|
5
|
Actual
|
-20,046
|
-20,046
|
Pass
|
6
|
Budget
|
-48,335
|
-48,335
|
Pass
|
7
|
Variance
|
28,289
|
28,289
|
Pass
|
8
|
Var%
|
-59
|
-59
|
Pass
|
Group : Blue Label Inc. - Apparel Women -> Sales net -> Sales Interunit
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
-13,956
|
-13,956
|
Pass
|
2
|
Budget
|
0
|
0
|
Pass
|
3
|
Variance
|
-13,956
|
-13,956
|
Pass
|
4
|
Var%
|
0
|
0
|
Pass
|
5
|
Actual
|
-308,069
|
-308,069
|
Pass
|
6
|
Budget
|
0
|
0
|
Pass
|
7
|
Variance
|
-308,069
|
-308,069
|
Pass
|
8
|
Var%
|
0
|
0
|
Pass
|
Group : Marc 4 - Accessories > Cost of goods sold > Purchases
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
Null
|
Null
|
Pass
|
2
|
Budget
|
60,669
|
60,669
|
Pass
|
3
|
Variance
|
-60,669
|
-60,669
|
Pass
|
4
|
Var%
|
-100
|
-100
|
Pass
|
5
|
Actual
|
51,162
|
51,162
|
Pass
|
6
|
Budget
|
151,672
|
151,672
|
Pass
|
7
|
Variance
|
-100,510
|
-100,510
|
Pass
|
8
|
Var%
|
66
|
66
|
Pass
|
Group : NEC Canada Corp - Accessories > Selling and distribution expenses > Commissions
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BOBI 4.0
|
Pass/Fail
|
1
|
Actual
|
204
|
204
|
Pass
|
2
|
Budget
|
0
|
0
|
Pass
|
3
|
Variance
|
204
|
204
|
Pass
|
4
|
Var%
|
0
|
0
|
Pass
|
5
|
Actual
|
358
|
358
|
Pass
|
6
|
Budget
|
0
|
0
|
Pass
|
7
|
Variance
|
358
|
358
|
Pass
|
8
|
Var%
|
0
|
0
|
Pass
|
Reference Document(Specification)
2013-04-18 - 4674.1200 - Spec - BI Reports Issues